In [1]:
#analysis for NETFLIX company stock datasets
import numpy as np
import pandas as pd
from matplotlib import pyplot as plt
%matplotlib inline
import seaborn as sns
df_close=pd.DataFrame()
df_item=pd.read_json("https://api.iextrading.com/1.0/stock/nflx/chart/2y")
df_item.head(5)
#df_item.set_index('date',inplace=True)
#Took only 5 fetures out  of api
df_close=df_item[['date','high','low','open','close','volume']]
df_close.to_csv("mynetflixdata.csv", encoding='utf-8', index=True)
df = pd.read_csv('mynetflixdata.csv', index_col=0)
#for getting data only of 1 year that is 01-01-2017 to 31-12-2017
val=df.tail(1).index.item()
df['date'] = pd.to_datetime(df['date']) 
df['date'] = pd.date_range('2017-01-01', periods=val+1, freq='D')
mask = (df['date'] > '2017-01-01') & (df['date'] <= '2017-12-31')
df.loc[mask].to_csv("mynetflixdata.csv", encoding='utf-8', index=True)
dat=pd.read_csv('mynetflixdata.csv', index_col=0)
from datetime import datetime
sns.set_style('darkgrid')
dat['date'] = pd.to_datetime(dat['date'])
#set date as ndex
dat = dat.set_index('date')
#ploat graph of closing of stocks of netflix
dat['close'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Netflix', fontsize=20)

#ax = dat.plot()
Out[1]:
Text(0.5,0.98,'Netflix')
In [106]:
#ploat of the graph of opening rate of stocks of netflix
dat['open'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Netflix', fontsize=20)
Out[106]:
Text(0.5,0.98,'Netflix')
In [3]:
#graph of lowest rate of stock of netflix
plt.ylabel('$(USD)', fontsize=18)
dat['low'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Netflix', fontsize=20)
Out[3]:
Text(0.5,0.98,'Netflix')
In [4]:
#graph of volumes of stocks of netflix company
dat['volume'].plot(legend=True, figsize=(10,4))
plt.ylabel('Volume', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Netflix', fontsize=20)
Out[4]:
Text(0.5,0.98,'Netflix')
In [5]:
#graph of high value of stocks of netflix dataset
dat['high'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Netflix', fontsize=20)
Out[5]:
Text(0.5,0.98,'Netflix')
In [6]:
#graph of netflix stock's data for high,low,open,close,volume
dat1=dat[['high','low','open','close']]
ax = dat1.plot()
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Netflix', fontsize=20)
Out[6]:
Text(0.5,0.98,'Netflix')
In [7]:
#mean calculation of data of netflix'stocks
In [8]:
#here only closing rate of netflix with various time span
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['close'],i)
    
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  
In [9]:
dat[['close','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Netflix', fontsize=20)
Out[9]:
Text(0.5,0.98,'Netflix')
In [10]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['open'],i)
dat[['open','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4))    
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Netflix', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[10]:
Text(0.5,0.98,'Netflix')
In [11]:
#mean of netflix data of volume for various days
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['volume'],i)
dat[['volume','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4)) 
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Netflix', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  
Out[11]:
Text(0.5,0.98,'Netflix')
In [12]:
#mean of netflix data of low rate of stocks for various days span
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['low'],i)
dat[['low','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4)) 
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Netflix', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  
Out[12]:
Text(0.5,0.98,'Netflix')
In [13]:
#mean of high values for various days of netflix'stocks
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['high'],i)
dat[['high','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Netflix', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:6: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  
Out[13]:
Text(0.5,0.98,'Netflix')
In [14]:
#daily return of netflix stoks
# We'll use pct_change to find the percent change for each day
dat['Daily Return'] = dat['close'].pct_change()

# Lets plot the daily return percentage
dat['Daily Return'].plot(figsize=(12,4), legend=True, linestyle='--', marker='d')
plt.suptitle('Netflix', fontsize=20)
plt.xlabel('Months', fontsize=18)
Out[14]:
Text(0.5,0,'Months')
In [15]:
dat['Daily Return'].hist(bins=100)
plt.suptitle('Netflix', fontsize=20)
Out[15]:
Text(0.5,0.98,'Netflix')
In [16]:
dat
Out[16]:
high low open close volume mean for 30 days mean for 60 days mean for 90 days mean for 120 days mean for 150 days mean for 180 days mean for 210 days mean for 240 days mean for 270 days mean for 300 days mean for 330 days mean for 350 days Daily Return
date
2017-01-02 93.8800 90.7700 93.87 90.99 15199727 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
2017-01-03 91.9800 89.7700 90.78 90.01 9454685 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -0.010770
2017-01-04 91.6800 88.1500 90.62 91.66 10819033 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.018331
2017-01-05 90.4900 87.2100 87.53 88.44 11248582 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -0.035130
2017-01-06 88.0000 84.8100 87.88 85.33 13775706 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -0.035165
2017-01-07 88.8800 86.4100 87.41 87.97 11545631 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.030939
2017-01-08 91.9700 88.7000 89.67 91.06 11687079 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.035126
2017-01-09 91.7201 89.9000 90.91 91.48 9098971 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.004612
2017-01-10 97.0000 94.8000 95.00 96.67 16167210 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.056734
2017-01-11 101.2700 93.3100 95.20 97.91 25879367 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.012827
2017-01-12 96.0000 93.5500 95.03 94.60 16301211 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -0.033807
2017-01-13 95.3800 93.1800 94.70 95.10 9913509 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.005285
2017-01-14 97.4100 95.3000 96.00 97.06 8335375 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.020610
2017-01-15 96.8690 94.3000 96.19 94.67 13276161 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -0.024624
2017-01-16 96.7200 94.0900 95.07 95.97 11617410 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.013732
2017-01-17 96.7200 94.8000 96.26 96.43 8768863 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.004793
2017-01-18 98.2700 96.8000 97.00 98.02 9885009 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.016489
2017-01-19 98.7000 97.4100 98.52 98.39 9041865 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.003775
2017-01-20 99.8400 97.2400 98.43 98.81 28669659 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.004269
2017-01-21 86.7500 84.5000 85.43 85.84 55681209 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -0.131262
2017-01-22 88.4900 85.8200 86.67 87.91 23525141 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.024115
2017-01-23 88.3800 85.2100 88.30 85.99 16083996 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -0.021841
2017-01-24 86.5000 85.1100 86.48 85.89 11363917 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -0.001163
2017-01-25 87.8700 85.0100 85.73 87.66 14135027 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.020608
2017-01-26 93.1000 90.9000 91.03 91.41 19577623 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.042779
2017-01-27 92.0600 90.1000 91.50 92.04 8727517 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.006892
2017-01-28 92.2100 90.6800 91.92 91.65 6227698 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -0.004237
2017-01-29 91.7490 90.5900 91.19 91.25 6960222 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -0.004364
2017-01-30 94.6700 90.5000 91.23 94.37 10666945 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 0.034192
2017-01-31 94.0800 92.1800 94.00 93.56 9836233 93.287937 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN -0.008583
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
2017-12-02 204.3800 197.7700 200.11 199.48 23900118 188.652250 182.670778 175.283880 171.690173 166.591872 162.689500 158.495068 153.844851 149.103382 143.985149 139.442529 NaN -0.015788
2017-12-03 200.0100 194.2500 199.99 195.54 11198938 189.337250 182.859945 175.778102 172.082173 166.948605 163.009500 158.844258 154.162726 149.489049 144.336016 139.779287 NaN -0.019751
2017-12-04 195.2500 191.1600 193.01 195.13 7034602 189.833917 182.952373 176.217769 172.395090 167.278539 163.310667 159.171925 154.461976 149.853049 144.665749 140.092257 NaN -0.002097
2017-12-05 196.3800 193.7700 195.90 194.16 5995568 190.366917 183.058707 176.670713 172.727423 167.612739 163.620333 159.505639 154.756267 150.227123 144.997582 140.409408 NaN -0.004971
2017-12-06 194.8999 191.0346 194.17 192.47 6979994 190.781247 183.223205 177.141157 173.047089 167.927405 163.919777 159.825461 155.044142 150.587345 145.324215 140.706074 NaN -0.008704
2017-12-07 196.7350 191.4000 192.75 196.02 7069108 191.161413 183.419225 177.621212 173.370714 168.280305 164.211194 160.155152 155.348663 150.954549 145.661299 140.995362 NaN 0.018444
2017-12-08 197.0550 193.0100 195.38 193.77 5315269 191.579930 183.626475 178.082046 173.691256 168.641405 164.499999 160.492176 155.657350 151.320271 145.995049 141.301589 NaN -0.011478
2017-12-09 197.6100 194.0800 194.66 195.21 5185830 191.990657 183.877142 178.561046 174.024339 169.006805 164.791777 160.818652 155.994767 151.683530 146.329693 141.611377 NaN 0.007431
2017-12-10 200.6500 196.2200 197.20 199.54 8128567 192.514657 184.200895 179.064046 174.381006 169.381871 165.099282 161.159509 156.347892 152.043752 146.675926 141.924226 NaN 0.022181
2017-12-11 201.0990 197.0721 199.62 198.37 5439563 193.036290 184.535878 179.574034 174.714331 169.748465 165.405665 161.516457 156.700763 152.401749 147.025823 142.240074 NaN -0.005863
2017-12-12 198.5900 195.2180 198.21 196.43 5518595 193.448290 184.807878 180.022923 175.031581 170.091198 165.708332 161.859409 157.044388 152.741082 147.365823 142.548771 NaN -0.009780
2017-12-13 199.1990 196.0000 197.24 198.00 5017420 193.871590 185.096028 180.458801 175.351239 170.430591 166.023715 162.197547 157.387675 153.088226 147.708619 142.859314 NaN 0.007993
2017-12-14 199.4400 197.0901 197.45 199.32 3606332 194.187923 185.487362 180.930607 175.665072 170.772025 166.340382 162.527404 157.733592 153.432449 148.045936 143.165889 NaN 0.006667
2017-12-15 200.5500 197.9900 199.80 200.01 3678829 194.544590 185.922362 181.445607 175.993156 171.122325 166.660659 162.850261 158.074550 153.788078 148.387936 143.474526 NaN 0.003462
2017-12-16 202.4800 198.0900 200.00 200.13 5846581 195.075590 186.420695 181.997384 176.357322 171.491591 166.988993 163.176928 158.420467 154.156893 148.734704 143.785556 NaN 0.000600
2017-12-17 200.6100 194.8000 200.00 195.89 6467969 195.730923 186.890028 182.551829 176.721656 171.853991 167.303493 163.503690 158.760967 154.520374 149.073904 144.130586 141.293207 -0.021186
2017-12-18 197.0900 194.7400 196.00 196.44 4237398 196.189257 187.310195 183.070051 177.046989 172.206991 167.595715 163.812595 159.088884 154.878115 149.404604 144.459677 141.588093 0.002808
2017-12-19 194.4900 190.8100 194.46 193.90 5910216 196.607257 187.710028 183.583718 177.346072 172.544325 167.878659 164.112547 159.409175 155.220304 149.726304 144.781223 141.880979 -0.012930
2017-12-20 192.5900 189.5000 191.61 192.02 6622168 196.930257 188.076862 184.087273 177.631739 172.863925 168.149048 164.406547 159.715050 155.560526 150.041004 145.102708 142.169293 -0.009696
2017-12-21 196.0500 191.0000 191.12 195.08 4606951 197.371923 188.511528 184.590607 177.944822 173.207325 168.440604 164.702357 160.030384 155.842860 150.360104 145.430526 142.470893 0.015936
2017-12-22 195.8800 193.0000 193.64 195.71 3450513 197.911257 188.959695 185.064496 178.209656 173.541591 168.732937 164.990357 160.352050 156.114823 150.679070 145.741980 142.779122 0.003229
2017-12-23 195.4200 191.5300 194.54 192.12 4203072 198.201923 189.384528 185.511051 178.479406 173.880725 169.025826 165.284500 160.662217 156.380267 150.996970 146.055192 143.083522 -0.018343
2017-12-24 197.7000 193.7500 194.33 195.51 5678355 198.308923 189.852195 185.943273 178.753989 174.216591 169.341326 165.542785 160.982842 156.638971 151.324670 146.374859 143.385607 0.017645
2017-12-25 195.9500 192.6500 195.74 193.20 3906333 198.209923 190.264090 186.341273 179.020239 174.540258 169.636382 165.805452 161.279342 156.885860 151.646870 146.690620 143.683407 -0.011815
2017-12-26 194.3200 191.9000 193.30 194.10 3827474 198.040590 190.690257 186.707607 179.273476 174.875725 169.924826 166.066547 161.565050 157.131267 151.967937 146.992589 143.961464 0.004658
2017-12-27 197.5200 194.9710 195.04 196.23 4787311 198.014590 191.171090 187.085051 179.541476 175.247191 170.232937 166.336023 161.861592 157.386082 152.298504 147.306044 144.236464 0.010974
2017-12-28 196.7500 193.6300 196.58 196.32 5895402 198.032260 191.622257 187.215607 179.801892 175.605325 170.541326 166.599642 162.163467 157.640045 152.627770 147.615377 144.524321 0.000459
2017-12-29 196.9000 195.3300 196.65 195.75 2160535 197.974927 191.989757 187.323718 180.052559 175.954658 170.847437 166.864833 162.467092 157.891786 152.952470 147.928008 144.814379 -0.002903
2017-12-30 195.8500 194.0000 195.56 195.05 3210145 197.809263 192.316590 187.434051 180.297976 176.236858 171.137104 167.118928 162.761925 158.147156 153.270804 148.225311 145.095636 -0.003576
2017-12-31 199.6800 194.0100 195.34 199.18 6981094 197.704263 192.703257 187.524940 180.571392 176.553725 171.450271 167.393752 163.075592 158.420674 153.605870 148.539705 145.389381 0.021174

364 rows × 18 columns

In [17]:
#for google dataset
In [18]:
import numpy as np
import pandas as pd
from matplotlib import pyplot as plt
%matplotlib inline
import seaborn as sns
df_close=pd.DataFrame()
df_item=pd.read_json("https://api.iextrading.com/1.0/stock/googl/chart/2y")
df_item.head(5)
#df_item.set_index('date',inplace=True)
df_close=df_item[['date','high','low','open','close','volume']]
df_close.to_csv("mygoogledata.csv", encoding='utf-8', index=True)
df = pd.read_csv('mygoogledata.csv', index_col=0)
val=df.tail(1).index.item()
df['date'] = pd.to_datetime(df['date']) 
df['date'] = pd.date_range('2017-01-01', periods=val+1, freq='D')
mask = (df['date'] > '2017-01-01') & (df['date'] <= '2017-12-31')
df.loc[mask].to_csv("mygoogledata.csv", encoding='utf-8', index=True)
dat=pd.read_csv('mygoogledata.csv', index_col=0)
from datetime import datetime
sns.set_style('darkgrid')
dat['date'] = pd.to_datetime(dat['date'])
dat = dat.set_index('date')
dat['close'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Google', fontsize=20)
#ax = dat.plot()
Out[18]:
Text(0.5,0.98,'Google')
In [19]:
dat['open'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Google', fontsize=20)
Out[19]:
Text(0.5,0.98,'Google')
In [20]:
dat['low'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Google', fontsize=20)
Out[20]:
Text(0.5,0.98,'Google')
In [21]:
dat['high'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Google', fontsize=20)
Out[21]:
Text(0.5,0.98,'Google')
In [22]:
dat['volume'].plot(legend=True, figsize=(10,4))
plt.ylabel('Volume', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Google', fontsize=20)
Out[22]:
Text(0.5,0.98,'Google')
In [23]:
dat1=dat[['high','low','open','close']]
ax = dat1.plot()
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Google', fontsize=20)
Out[23]:
Text(0.5,0.98,'Google')
In [24]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['open'],i)
dat[['open','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4))   
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Google', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[24]:
Text(0.5,0.98,'Google')
In [25]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['close'],i)
dat[['close','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4))   
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Google', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[25]:
Text(0.5,0.98,'Google')
In [26]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['low'],i)
dat[['low','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Google', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[26]:
Text(0.5,0.98,'Google')
In [27]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['volume'],i)
dat[['volume','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4)) 
plt.ylabel('Volume', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Google', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[27]:
Text(0.5,0.98,'Google')
In [28]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['high'],i)
dat[['high','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4)) 
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Google', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[28]:
Text(0.5,0.98,'Google')
In [29]:
#daily return of google's stoks
# We'll use pct_change to find the percent change for each day
dat['Daily Return'] = dat['close'].pct_change()

# Lets plot the daily return percentage
dat['Daily Return'].plot(figsize=(12,4), legend=True, linestyle='--', marker='d')

plt.xlabel('Months', fontsize=18)
plt.suptitle('Google', fontsize=20)
Out[29]:
Text(0.5,0.98,'Google')
In [30]:
dat['Daily Return'].hist(bins=100)

plt.suptitle('Google', fontsize=20)
Out[30]:
Text(0.5,0.98,'Google')
In [31]:
#for FACEBOOK
In [32]:
import numpy as np
import pandas as pd
from matplotlib import pyplot as plt
%matplotlib inline
import seaborn as sns
df_close=pd.DataFrame()
df_item=pd.read_json("https://api.iextrading.com/1.0/stock/fb/chart/2y")
df_item.head(5)
#df_item.set_index('date',inplace=True)
df_close=df_item[['date','high','low','open','close','volume']]
df_close.to_csv("myfacebookdata.csv", encoding='utf-8', index=True)
df = pd.read_csv('myfacebookdata.csv', index_col=0)
val=df.tail(1).index.item()
df['date'] = pd.to_datetime(df['date']) 
df['date'] = pd.date_range('2017-01-01', periods=val+1, freq='D')
mask = (df['date'] > '2017-01-01') & (df['date'] <= '2017-12-31')
df.loc[mask].to_csv("myfacebookdata.csv", encoding='utf-8', index=True)
dat=pd.read_csv('myfacebookdata.csv', index_col=0)
from datetime import datetime
sns.set_style('darkgrid')
dat['date'] = pd.to_datetime(dat['date'])
dat = dat.set_index('date')
dat['close'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Facebook', fontsize=20)
#ax = dat.plot()
Out[32]:
Text(0.5,0.98,'Facebook')
In [33]:
dat['open'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Facebook', fontsize=20)
Out[33]:
Text(0.5,0.98,'Facebook')
In [34]:
dat['low'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Facebook', fontsize=20)
Out[34]:
Text(0.5,0.98,'Facebook')
In [35]:
dat['high'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Facebook', fontsize=20)
Out[35]:
Text(0.5,0.98,'Facebook')
In [36]:
dat['volume'].plot(legend=True, figsize=(10,4))
plt.ylabel('volume', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Facebook', fontsize=20)
Out[36]:
Text(0.5,0.98,'Facebook')
In [37]:
dat1=dat[['high','low','open','close']]
ax = dat1.plot()
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Facebook', fontsize=20)
Out[37]:
Text(0.5,0.98,'Facebook')
In [38]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['volume'],i)
dat[['volume','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4)) 
plt.ylabel('volume', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Facebook', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[38]:
Text(0.5,0.98,'Facebook')
In [39]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['open'],i)
dat[['open','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Facebook', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[39]:
Text(0.5,0.98,'Facebook')
In [40]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['close'],i)
dat[['close','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4))    
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Facebook', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[40]:
Text(0.5,0.98,'Facebook')
In [41]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['low'],i)
dat[['low','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4))   
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Facebook', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[41]:
Text(0.5,0.98,'Facebook')
In [42]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['high'],i)
dat[['high','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4)) 
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Facebook', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[42]:
Text(0.5,0.98,'Facebook')
In [43]:
#daily return of Facebook stoks
# We'll use pct_change to find the percent change for each day
dat['Daily Return'] = dat['close'].pct_change()

# Lets plot the daily return percentage
dat['Daily Return'].plot(figsize=(12,4), legend=True, linestyle='--', marker='d')
plt.xlabel('Months', fontsize=18)
plt.suptitle('Facebook', fontsize=20)
Out[43]:
Text(0.5,0.98,'Facebook')
In [44]:
dat['Daily Return'].hist(bins=100)

plt.suptitle('Facebook', fontsize=20)
Out[44]:
Text(0.5,0.98,'Facebook')
In [45]:
# FOR AMAZON
In [46]:
import numpy as np
import pandas as pd
from matplotlib import pyplot as plt
%matplotlib inline
import seaborn as sns
df_close=pd.DataFrame()
df_item=pd.read_json("https://api.iextrading.com/1.0/stock/amzn/chart/2y")
df_item.head(5)
#df_item.set_index('date',inplace=True)
df_close=df_item[['date','high','low','open','close','volume']]
df_close.to_csv("myamazondata.csv", encoding='utf-8', index=True)
df = pd.read_csv('myamazondata.csv', index_col=0)
val=df.tail(1).index.item()
df['date'] = pd.to_datetime(df['date']) 
df['date'] = pd.date_range('2017-01-01', periods=val+1, freq='D')
mask = (df['date'] > '2017-01-01') & (df['date'] <= '2017-12-31')
df.loc[mask].to_csv("myamazondata.csv", encoding='utf-8', index=True)
dat=pd.read_csv('myamazondata.csv', index_col=0)
from datetime import datetime
sns.set_style('darkgrid')
dat['date'] = pd.to_datetime(dat['date'])
dat = dat.set_index('date')
dat['close'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Amazon', fontsize=20)
#ax = dat.plot()
Out[46]:
Text(0.5,0.98,'Amazon')
In [47]:
dat['open'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Amazon', fontsize=20)
Out[47]:
Text(0.5,0.98,'Amazon')
In [48]:
dat['low'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Amazon', fontsize=20)
Out[48]:
Text(0.5,0.98,'Amazon')
In [49]:
dat['high'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Amazon', fontsize=20)
Out[49]:
Text(0.5,0.98,'Amazon')
In [50]:
dat['volume'].plot(legend=True, figsize=(10,4))
plt.ylabel('volume', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Amazon', fontsize=20)
Out[50]:
Text(0.5,0.98,'Amazon')
In [51]:
dat1=dat[['high','low','open','close']]
ax = dat1.plot()
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Amazon', fontsize=20)
Out[51]:
Text(0.5,0.98,'Amazon')
In [52]:
#daily return of Amazon's stoks
# We'll use pct_change to find the percent change for each day
dat['Daily Return'] = dat['close'].pct_change()

# Lets plot the daily return percentage
dat['Daily Return'].plot(figsize=(12,4), legend=True, linestyle='--', marker='d')
plt.ylabel('precent', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Amazon', fontsize=20)
Out[52]:
Text(0.5,0.98,'Amazon')
In [53]:
dat['Daily Return'].hist(bins=100)

plt.suptitle('Amazon', fontsize=20)
Out[53]:
Text(0.5,0.98,'Amazon')
In [54]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['close'],i)
dat[['close','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4)) 
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Amazon', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[54]:
Text(0.5,0.98,'Amazon')
In [55]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['open'],i)
dat[['open','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4))   
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Amazon', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[55]:
Text(0.5,0.98,'Amazon')
In [56]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['low'],i)
dat[['low','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4))   
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Amazon', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[56]:
Text(0.5,0.98,'Amazon')
In [57]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['high'],i)
dat[['high','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4)) 
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Amazon', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[57]:
Text(0.5,0.98,'Amazon')
In [58]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['volume'],i)
dat[['volume','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4)) 
plt.ylabel('volume', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Amazon', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[58]:
Text(0.5,0.98,'Amazon')
In [59]:
#FOR APPLE
In [60]:
import numpy as np
import pandas as pd
from matplotlib import pyplot as plt
%matplotlib inline
import seaborn as sns
df_close=pd.DataFrame()
df_item=pd.read_json("https://api.iextrading.com/1.0/stock/aapl/chart/2y")
df_item.head(5)
#df_item.set_index('date',inplace=True)
df_close=df_item[['date','high','low','open','close','volume']]
df_close.to_csv("myappledata.csv", encoding='utf-8', index=True)
df = pd.read_csv('myappledata.csv', index_col=0)
val=df.tail(1).index.item()
df['date'] = pd.to_datetime(df['date']) 
df['date'] = pd.date_range('2017-01-01', periods=val+1, freq='D')
mask = (df['date'] > '2017-01-01') & (df['date'] <= '2017-12-31')
df.loc[mask].to_csv("myappledata.csv", encoding='utf-8', index=True)
dat=pd.read_csv('myappledata.csv', index_col=0)
from datetime import datetime
sns.set_style('darkgrid')
dat['date'] = pd.to_datetime(dat['date'])
dat = dat.set_index('date')
dat['close'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Apple', fontsize=20)
#ax = dat.plot()
Out[60]:
Text(0.5,0.98,'Apple')
In [61]:
dat['open'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Apple', fontsize=20)
Out[61]:
Text(0.5,0.98,'Apple')
In [62]:
dat['low'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Apple', fontsize=20)
Out[62]:
Text(0.5,0.98,'Apple')
In [63]:
dat['high'].plot(legend=True, figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Apple', fontsize=20)
Out[63]:
Text(0.5,0.98,'Apple')
In [64]:
dat['volume'].plot(legend=True, figsize=(10,4))
plt.ylabel('volumes', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Apple', fontsize=20)
Out[64]:
Text(0.5,0.98,'Apple')
In [65]:
#daily return of Apple's stoks
# We'll use pct_change to find the percent change for each day
dat['Daily Return'] = dat['close'].pct_change()

# Lets plot the daily return percentage
dat['Daily Return'].plot(figsize=(12,4), legend=True, linestyle='--', marker='d')
plt.ylabel('percent', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Apple', fontsize=20)
Out[65]:
Text(0.5,0.98,'Apple')
In [66]:
dat['Daily Return'].hist(bins=100)

plt.suptitle('Apple', fontsize=20)
Out[66]:
Text(0.5,0.98,'Apple')
In [67]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['open'],i)
dat[['open','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4)) 
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Apple', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[67]:
Text(0.5,0.98,'Apple')
In [68]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['close'],i)
dat[['close','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4)) 
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Apple', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[68]:
Text(0.5,0.98,'Apple')
In [69]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['low'],i)
dat[['low','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Apple', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[69]:
Text(0.5,0.98,'Apple')
In [70]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['high'],i)
dat[['high','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4))
plt.ylabel('$(USD)', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Apple', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[70]:
Text(0.5,0.98,'Apple')
In [100]:
Span_day = [30,60,90,120,150,180,210,240,270,300,330,350]

for i in Span_day:
    column_name = 'mean for %s days' %(str(i))
    dat[column_name] = pd.rolling_mean(dat['volume'],i)
dat[['volume','mean for 30 days','mean for 60 days','mean for 90 days','mean for 120 days','mean for 150 days','mean for 180 days','mean for 210 days','mean for 240 days','mean for 270 days','mean for 300 days','mean for 330 days','mean for 350 days']].plot(subplots=False,figsize=(10,4))  
plt.ylabel('volume', fontsize=18)
plt.xlabel('Months', fontsize=18)
plt.suptitle('Apple', fontsize=20)
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=30,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=60,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=90,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=120,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=150,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=180,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=210,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=240,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=270,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=300,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=330,center=False).mean()
  """
C:\Users\mohit\Anaconda3\lib\site-packages\ipykernel_launcher.py:5: FutureWarning: pd.rolling_mean is deprecated for Series and will be removed in a future version, replace with 
	Series.rolling(window=350,center=False).mean()
  """
Out[100]:
Text(0.5,0.98,'Apple')
In [72]:
#here i take datas's of all company and merge them in a single datafrmae i took close price of all company for one year
In [73]:
import numpy as np
import pandas as pd
from matplotlib import pyplot as plt
%matplotlib inline
import seaborn as sns
df_close=pd.DataFrame()
df_item=pd.read_json("https://api.iextrading.com/1.0/stock/nflx/chart/2y")
#df_item.head(5)
#df_item.set_index('date',inplace=True)
df_close=df_item[['date','high','low','open','close','volume']]
df_close.to_csv("mynetflixdata1.csv", encoding='utf-8', index=True)
df = pd.read_csv('mynetflixdata1.csv', index_col=0)
val=df.tail(1).index.item()
df['date'] = pd.to_datetime(df['date']) 
df['date'] = pd.date_range('2017-01-01', periods=val+1, freq='D')
mask = (df['date'] > '2017-01-01') & (df['date'] <= '2017-12-31')
df.loc[mask].to_csv("mynetflixdata1.csv", encoding='utf-8', index=True)
dat1=pd.read_csv('mynetflixdata1.csv', index_col=0)

####
df_item=pd.read_json("https://api.iextrading.com/1.0/stock/googl/chart/2y")
#df_item.head(5)
#df_item.set_index('date',inplace=True)
df_close=df_item[['date','high','low','open','close','volume']]
df_close.to_csv("mygoogledata1.csv", encoding='utf-8', index=True)
df = pd.read_csv('mygoogledata1.csv', index_col=0)
val=df.tail(1).index.item()
df['date'] = pd.to_datetime(df['date']) 
df['date'] = pd.date_range('2017-01-01', periods=val+1, freq='D')
mask = (df['date'] > '2017-01-01') & (df['date'] <= '2017-12-31')
df.loc[mask].to_csv("mygoogledata1.csv", encoding='utf-8', index=True)
dat2=pd.read_csv('mygoogledata1.csv', index_col=0)
######
df_item=pd.read_json("https://api.iextrading.com/1.0/stock/fb/chart/2y")
#df_item.head(5)
#df_item.set_index('date',inplace=True)
df_close=df_item[['date','high','low','open','close','volume']]
df_close.to_csv("myfacebookdata1.csv", encoding='utf-8', index=True)
df = pd.read_csv('myfacebookdata1.csv', index_col=0)
val=df.tail(1).index.item()
df['date'] = pd.to_datetime(df['date']) 
df['date'] = pd.date_range('2017-01-01', periods=val+1, freq='D')
mask = (df['date'] > '2017-01-01') & (df['date'] <= '2017-12-31')
df.loc[mask].to_csv("myfacebookdata1.csv", encoding='utf-8', index=True)
dat3=pd.read_csv('myfacebookdata1.csv', index_col=0)
#####
df_item=pd.read_json("https://api.iextrading.com/1.0/stock/amzn/chart/2y")
#df_item.head(5)
#df_item.set_index('date',inplace=True)
df_close=df_item[['date','high','low','open','close','volume']]
df_close.to_csv("myamazondata1.csv", encoding='utf-8', index=True)
df = pd.read_csv('myamazondata1.csv', index_col=0)
val=df.tail(1).index.item()
df['date'] = pd.to_datetime(df['date']) 
df['date'] = pd.date_range('2017-01-01', periods=val+1, freq='D')
mask = (df['date'] > '2017-01-01') & (df['date'] <= '2017-12-31')
df.loc[mask].to_csv("myamazondata1.csv", encoding='utf-8', index=True)
dat4=pd.read_csv('myamazondata1.csv', index_col=0)
#######
df_item=pd.read_json("https://api.iextrading.com/1.0/stock/aapl/chart/2y")
#df_item.head(5)
#df_item.set_index('date',inplace=True)
df_close=df_item[['date','high','low','open','close','volume']]
df_close.to_csv("myappledata1.csv", encoding='utf-8', index=True)
df = pd.read_csv('myappledata1.csv', index_col=0)
val=df.tail(1).index.item()
df['date'] = pd.to_datetime(df['date']) 
df['date'] = pd.date_range('2017-01-01', periods=val+1, freq='D')
mask = (df['date'] > '2017-01-01') & (df['date'] <= '2017-12-31')
df.loc[mask].to_csv("myappledata1.csv", encoding='utf-8', index=True)
dat5=pd.read_csv('myappledata1.csv', index_col=0)                 
                 
In [74]:
df_close=pd.DataFrame()
#make a list
df_close=[dat1['close'],dat2['close'],dat3['close'],dat4['close'],dat5['close']]
#convert o the dataframe
f = pd.DataFrame(df_close)
#transpose it
f1=f.transpose()
#change the header's name
f1.columns = ['Netflix', 'Google','Facebook','Amazon','Apple']
In [75]:
f1
Out[75]:
Netflix Google Facebook Amazon Apple
1 90.99 708.88 114.38 715.82 92.6672
2 90.01 710.47 113.91 710.60 92.3194
3 91.66 714.87 115.08 722.08 92.8508
4 88.44 685.20 112.08 698.96 90.2421
5 85.33 681.14 108.97 691.36 88.9281
6 87.97 691.26 112.70 707.95 90.4257
7 91.06 695.19 114.16 715.60 91.2083
8 91.48 703.53 114.28 715.62 92.3677
9 96.67 710.25 114.19 725.68 92.6479
10 97.91 704.89 114.00 728.10 91.7783
11 94.60 708.97 116.70 737.61 92.3001
12 95.10 707.26 115.85 736.57 92.6962
13 97.06 717.78 117.24 745.81 93.4112
14 94.67 727.20 117.87 753.78 93.7011
15 95.97 732.51 117.93 748.21 94.1262
16 96.43 729.48 116.78 742.63 93.5948
17 98.02 735.80 117.29 741.20 95.4499
18 98.39 735.63 116.86 735.44 95.4402
19 98.81 753.20 119.37 736.07 96.4547
20 85.84 753.41 120.61 739.95 96.4934
21 87.91 757.08 121.92 745.72 96.5803
22 85.99 754.41 120.61 744.43 96.0682
23 85.89 759.28 121.00 744.86 95.3243
24 87.66 757.52 121.63 739.61 94.0489
25 91.41 757.65 121.22 735.59 93.4015
26 92.04 761.97 123.34 736.67 99.4692
27 91.65 765.84 125.00 752.61 100.8122
28 91.25 791.34 123.94 758.81 100.6866
29 94.37 800.94 124.31 767.74 102.4644
30 93.56 800.12 123.09 760.58 100.9475
... ... ... ... ... ...
335 199.48 1011.00 176.11 1009.13 158.6342
336 195.54 1012.74 176.03 997.00 157.9323
337 195.13 1001.84 174.56 986.61 154.1956
338 194.16 1005.07 174.98 982.91 154.4625
339 192.47 985.54 171.27 966.30 154.3834
340 196.02 988.49 171.80 975.90 155.3028
341 193.77 991.46 170.60 972.91 154.6206
342 195.21 991.42 170.63 972.43 155.6092
343 199.54 1033.67 177.88 1100.95 161.1847
344 198.37 1033.13 179.87 1110.85 164.8127
345 196.43 1033.04 180.06 1105.28 167.1062
346 198.00 1042.60 182.66 1103.68 164.9808
347 199.32 1042.97 178.92 1094.22 166.1868
348 200.01 1049.99 178.92 1111.60 170.5266
349 200.13 1042.68 180.17 1120.66 172.2566
350 195.89 1052.39 180.25 1123.17 172.8101
351 196.44 1058.29 179.56 1132.88 174.2238
352 193.90 1047.72 179.30 1129.13 173.8679
353 192.02 1044.15 178.46 1125.35 173.2925
354 195.08 1041.20 178.77 1129.17 172.5980
355 195.71 1041.64 178.07 1136.84 169.9887
356 192.12 1036.41 177.95 1126.69 167.7466
357 195.51 1048.47 179.59 1137.29 169.7506
358 193.20 1035.89 179.00 1129.88 168.8081
359 194.10 1034.66 178.74 1126.31 168.6395
360 196.23 1050.30 181.86 1139.49 171.7745
361 196.32 1051.92 180.87 1156.16 173.5802
362 195.75 1056.52 182.78 1186.00 173.5901
363 195.05 1072.01 183.03 1195.83 172.7171
364 199.18 1063.29 182.42 1193.60 171.7051

364 rows × 5 columns

In [95]:
f1.plot()
plt.rc('figure', figsize=(20, 10))
In [76]:
#graph of closing prize of stocks of all comapies with pairplot
sns.pairplot(f1.dropna(),size=3)
Out[76]:
<seaborn.axisgrid.PairGrid at 0x349eba5908>
In [77]:
#compairing closing price of the comapny with joinplot
sns.jointplot(f1['Google'],f1['Amazon'],dat,kind='scatter',color='orange')
Out[77]:
<seaborn.axisgrid.JointGrid at 0x34a139c978>
In [78]:
sns.jointplot(f1['Facebook'],f1['Apple'],dat, kind='reg', size=8, color='skyblue')
Out[78]:
<seaborn.axisgrid.JointGrid at 0x34a139c9e8>
In [79]:
# Set up the figure by naming it returns_fig, call PairGrid on the DataFrame
returns_fig = sns.PairGrid(f1.dropna())

# Using map_upper we can specify what the upper triangle will look like.
returns_fig.map_upper(plt.scatter,color='purple')

# We can also define the lower triangle in the figure, including the plot type (kde) & the color map (BluePurple)
returns_fig.map_lower(sns.kdeplot,cmap='cool_d')

# Finally we'll define the diagonal as a series of histogram plots of the daily return
returns_fig.map_diag(plt.hist,bins=30)
C:\Users\mohit\Anaconda3\lib\site-packages\matplotlib\contour.py:967: UserWarning: The following kwargs were not used by contour: 'label', 'color'
  s)
Out[79]:
<seaborn.axisgrid.PairGrid at 0x34a1b8e0b8>
In [80]:
#ploating of closing price of all 5 comapny with heatmap
sns.heatmap(f1.corr(),annot=True,fmt=".3g",cmap='YlGnBu')
Out[80]:
<matplotlib.axes._subplots.AxesSubplot at 0x34a27f3630>
In [86]:
#calculate standard deviation in closing price of all companies
f2=f1.std()
In [102]:
f2.plot.bar()
plt.suptitle('standard deviation', fontsize=20)
plt.rc('figure', figsize=(10, 10))